package com.auxgroup.hr.front.dao.repository;

import com.auxgroup.hr.front.dao.domain.PsCWfWkotHdr;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

/**
 * @author lv-PC
 *
 */
@Repository
public interface PsCWfWkotHdrRepository extends
JpaRepository<PsCWfWkotHdr,String>,JpaSpecificationExecutor<PsCWfWkotHdr> {
	
 	@Modifying
 	@Transactional
    @Query(value = "delete from PsCWfWkotHdr where cTransactionNbr=:transNum")
    Integer deleteByTransNum(@Param("transNum") String transNum);
}